<html>
<body>
<h1>Klant/Bestelgegevens</h1>
<?php
require('../connect_db.php');

$bestelklant_result = mysql_query("SELECT * FROM klantbestel");

echo "<table border='1'>
	<tr>
			<td width='150' align='center'><strong>Bestelid</strong></td>
			<td width='150' align='center'><strong>Klantid</strong></td>
			<td width='150' align='center'><strong>Naam</strong></td>
			<td width='150' align='center'><strong>Adres</strong></td>
			<td width='150' align='center'><strong>Postcode</strong></td>
			<td width='150' align='center'><strong>Stad</strong></td>
			<td width='150' align='center'><strong>Telefoonnummer</strong></td>
	</tr>";
	
while($bestelklant_row = mysql_fetch_array($bestelklant_result))
	{
		$bestelklant_id = $bestelklant_result['bestelnr'];
		echo "<tr>
					<td align='left'>".$bestelklant_row['Bestelid']."</td>
					<td align='left'>".$bestelklant_row['Klantid']."</td>
					<td align='left'>".$bestelklant_row['Naam']."</td>
					<td align='left'>".$bestelklant_row['Adres']."</td>
					<td align='left'>".$bestelklant_row['Postcode']."</td>
					<td align='left'>".$bestelklant_row['Stad']."</td>
					<td align='left'>".$bestelklant_row['Telefoonnummer']."</td>
			
					</tr>";
	}
?>
</body>
</html>